package com.wondertek.service.mapper.business;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.wondertek.service.dto.app.req.AddModeTimedTaskReq;
import com.wondertek.service.entity.business.RoomModeTimedTaskPo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author wangyu
 */

public interface RoomModeTimedTaskMapper extends BaseMapper<RoomModeTimedTaskPo> {

    @Select("select a.id,a.task_id,b.job_name name,a.room_id,a.mode,a.time,a.week,b.status from room_mode_timed_task a left join sys_job b on a.task_id = b.id where a.is_delete = 0 and b.is_delete = 0")
    Page<AddModeTimedTaskReq> findModeTimedTask(Page page);
}
